University of Wyoming Extension
Wyoming Ranch Tools

Tools

Home

Partial Budget

NPV Tool

Aum Value Tool

Genetic Investment

Sprayer Calibration

Stocking Tool



Fact Sheets

Partial Bugdet

Pasture Leasing

Genetic Investment Sheet

Sprayer Calibration

Stocking Rate



External Links

Cattle Market Analysis 		Ranch Tools Partial Budget.xlsx
Please fill all required fields
Wyoming Master Stockman
Partial Budget Tool
 
Proposed Change
Additional Costs   Additional Income
  Number Price/       Number Price/  
Description of Units Cost Total   Description of Units Cost Total
 
 
 
 
 
 
 
 
 
 
 
Reduced Income   Reduced Costs
  Number Price/       Number Price/  
Description of Units Cost Total   Description of Units Cost Total
 
 
 
 
 
 
 
 
 
 
 
Total Additional Costs and Reduced Income   Total Additional Income and Reduced Costs
    Net Income or Loss
Sensitivity Analysis
10% General Factor   5% General Factor
  Worst Likely Best     Worst Likely Best
  Revenue Revenue Revenue     Revenue Revenue Revenue
Worst-Cost   Worst-Cost
Likely-Cost   Likely-Cost
Best-Cost   Best-Cost
Wyoming Master Stockman
Partial Budget Tool
 
Proposed Change Retain Steers Through Summer Grass-100 Steers
Additional Costs   Additional Income
  Number Price/       Number Price/  
Description of Units Cost Total   Description of Units Cost Total
Background Feed-hd/days 21500 $0.65   9 Wt Steers - 97 steers $1.10
Pasture-Animal Units 450 $16.00        
Transportation - 2 trucks 400 $3.75        
Vet & Medicine - per hd 100 $2.50        
Fuel / Repairs 1 $700.00        
Misc. 1 $250.00        
             
             
             
             
             
Reduced Income   Reduced Costs
  Number Price/       Number Price/  
Description of Units Cost Total   Description of Units Cost Total
5 wt Steers $1.30   Transportation - 1 truck 200 $3.75
Interest at 8% - 365 Days 1 $5,200.00        
             
             
             
             
             
             
             
             
             
Total Additional Costs and Reduced Income   Total Additional Income and Reduced Costs
    Net Income or Loss
Sensitivity Analysis
10% General Factor   5% General Factor
  Worst Likely Best     Worst Likely Best
  Revenue Revenue Revenue     Revenue Revenue Revenue
Worst-Cost   Worst-Cost
Likely-Cost   Likely-Cost
Best-Cost   Best-Cost
Wyoming Master Stockman
Partial Budget Tool
 
Proposed Change Winter Pasture 1100 Head of Lambs on California Alfalfa Pastures
Additional Costs   Additional Income
  Number Price/       Number Price/  
Description of Units Cost Total   Description of Units Cost Total
Pasture rent & labor 130 days 143000 $0.35   1078 Fed Lambs 135 lbs 145530 $1.75
Oct 1 - Feb 10       2% Death Loss    
Trucking to CA - 1115 miles 2230 $3.55        
2 Trucks to CA            
Trucking to CO - 1115 miles 3345 $3.55        
3 Trucks to CO            
Misc. per Head 1100 $1.00        
             
             
             
             
Reduced Income   Reduced Costs
  Number Price/       Number Price/  
Description of Units Cost Total   Description of Units Cost Total
1100 Feeder Lambs 85 lbs 93500 $1.90   Trucking to CO 470 $3.75
Interest at 6% - 130 Days 1 $3,795.00        
             
             
             
             
             
             
             
             
             
Total Additional Costs and Reduced Income   Total Additional Income and Reduced Costs
    Net Income or Loss
Sensitivity Analysis
10% General Factor   5% General Factor
  Worst Likely Best     Worst Likely Best
  Revenue Revenue Revenue     Revenue Revenue Revenue
Worst-Cost   Worst-Cost
Likely-Cost   Likely-Cost
Best-Cost   Best-Cost
Wyoming Master Stockman
Partial Budget Tool
 
Proposed Change Sell 160 of 300 cows / Buy Hay
Additional Costs   Additional Income
  Number Price/       Number Price/  
Description of Units Cost Total   Description of Units Cost Total
Hay 3.25 ton X 160 hd 520 $200.00   Calves 160 x 90% x 550 x 4 316800 $1.80
2 ton norm + 1.25 ton for drought       90% calf crop for 4 years average weight 550    
Annual Cow Cost 3 yrs X 160 $650.00        
cost for keeping the 160 cows            
             
             
             
             
             
             
             
Reduced Income   Reduced Costs
  Number Price/       Number Price/  
Description of Units Cost Total   Description of Units Cost Total
Culled Pairs 160 $1,400.00   Bred Cows 160 $1,200.00
Hay Sales 320 ton X 3 Yrs 960 $125.00   by keeping the 160 head you do not need to restock    
hay that could be sold if 160 cows were culled       at the end of the 4 years    
             
             
             
             
             
             
             
             
Total Additional Costs and Reduced Income   Total Additional Income and Reduced Costs
    Net Income or Loss
Sensitivity Analysis
10% General Factor   5% General Factor
  Worst Likely Best     Worst Likely Best
  Revenue Revenue Revenue     Revenue Revenue Revenue
Worst-Cost   Worst-Cost
Likely-Cost   Likely-Cost
Best-Cost   Best-Cost
Wyoming Master Wool Grower
Partial Budget Tool
 
 
Enter appropriate information in gold cells - dark brown cells are automatically calculated  
 
Description - Enter any description that makes sense for you.  
Number of Units - Enter the appropriate number of pounds, tons, days, head, etc. If you  
just want to enter the total price/cost in the following field enter a "1" for the number of units  
Price/Cost - Enter the price/cost per unit, or the total price/cost if you entered a "1" for the units  
   
Powered By SpreadsheetConverter